2010-04-19 14:26:06 SelectCommander:
 SELECT  0 B_SEL,ACC_CLEAR_APP.*,pub_customer.customer_cname    FROM ACC_CLEAR_APP LEFT JOIN pub_customer ON  pub_customer.customer_id=company_profile_id WHERE 1=1 AND CLEAR_STATE=0  AND CREATE_DATE >=TO_DATE('2010-04-19', 'yyyy-mm-dd') AND CREATE_DATE < TO_DATE('2010-04-20', 'yyyy-mm-dd') ORDER BY DEPARTMENT_CODE,APPLICATE_BY,CLEAR_APP_ID
2010-04-19 16:17:52 SelectCommander:
 SELECT  0 B_SEL,ACC_CLEAR_APP.*,pub_customer.customer_cname FROM ACC_CLEAR_APP LEFT JOIN pub_customer ON  pub_customer.customer_id=company_profile_id   WHERE 1=1 AND CLEAR_STATE=0  AND CREATE_DATE >=TO_DATE('2010-04-19', 'yyyy-mm-dd') AND CREATE_DATE < TO_DATE('2010-04-20', 'yyyy-mm-dd') ORDER BY DEPARTMENT_CODE,APPLICATE_BY,CLEAR_APP_ID
2010-04-19 16:17:53 SelectCommander:
 SELECT  0 B_SEL,ACC_CLEAR_APP.*,pub_customer.customer_cname FROM ACC_CLEAR_APP LEFT JOIN pub_customer ON  pub_customer.customer_id=company_profile_id   WHERE 1=1 AND CLEAR_STATE=0  AND CREATE_DATE >=TO_DATE('2010-04-19', 'yyyy-mm-dd') AND CREATE_DATE < TO_DATE('2010-04-20', 'yyyy-mm-dd') ORDER BY DEPARTMENT_CODE,APPLICATE_BY,CLEAR_APP_ID
2010-04-19 16:18:22 SelectCommander:
 SELECT  0 B_SEL,ACC_CLEAR_APP.*,pub_customer.customer_cname    FROM ACC_CLEAR_APP LEFT JOIN pub_customer ON  pub_customer.customer_id=company_profile_id WHERE 1=1 AND CLEAR_STATE=0  AND CREATE_DATE >=TO_DATE('2010-04-19', 'yyyy-mm-dd') AND CREATE_DATE < TO_DATE('2010-04-20', 'yyyy-mm-dd') ORDER BY DEPARTMENT_CODE,APPLICATE_BY,CLEAR_APP_ID
2010-04-19 16:51:40 SelectCommander:
 SELECT  0 B_SEL,ACC_CLEAR_APP.*,pub_customer.customer_cname    FROM ACC_CLEAR_APP LEFT JOIN pub_customer ON  pub_customer.customer_id=company_profile_id WHERE 1=1 AND CLEAR_STATE=0  AND CREATE_DATE >=TO_DATE('2010-04-19', 'yyyy-mm-dd') AND CREATE_DATE < TO_DATE('2010-04-20', 'yyyy-mm-dd') ORDER BY DEPARTMENT_CODE,APPLICATE_BY,CLEAR_APP_ID
